package com.lanyou.cook.repository.kettle;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.Repository;
import org.springframework.data.repository.query.Param;

import com.lanyou.cook.entity.kettle.KettleJob;



public interface KettleStepDatabaseRepository extends Repository<KettleJob,Integer>{
	@Query(nativeQuery = true,
			value = 
			 "SELECT COUNT(ID_DATABASE)"+
			 " FROM R_STEP_DATABASE"+
			 " WHERE ID_DATABASE = :databaseId"
		)
	int findByDatabaseId(@Param("databaseId")int databaseId);
	
}